2015-02-16 - 17269 - Service Request - SH130 multiple ship dates for PO #CrystalReportsSupport

Service Request

17269 - SH130 multiple ship dates for PO

Problem Summary


Need to check SH130 report showing purchase order numbers with shipped dates of the 9th and 10th.

Admin Info


Purpose
Need to check SH130 report showing purchase order numbers with shipped dates of the 9th and 10th.
Requested by
Michelle Seifert
Issue Date
02-16-2015
Resolved by
Dhananjay G
Resolved Date
02-19-2015
Document Status
Complete

Detailed Problem Description


1. In the below files, purchase order numbers are showing shipped dates as the 9th and 10th. A few additional attachments from the business. It looks like their concern is with the 2nd half of the PO number in the report, identified as the customer order number on the attached images (200012128, 7087007040, 7087007041 & 200012141).
~ced2c8514e83270f62.xls
~ced2c850fc1c86fb02.xls

Untitled.png

Solution Analysis and Recommendations


1. Need to analyze the attached files.
2. Need to validate if PO number is having any duplicates in both files.
3. Need to check if PO number associated with shipped date in NEP.
4. Need to check the values at the source table VBAK-BSTNK.
5. Need to check with functional team regarding 2nd half of the PO number and related issue.

Resolution


1. Analyzed the attached files for issue.
2. Validated both the files but there is no common PO number.
3. Checked PO number associated with shipped date in NEP.
4. Used the direct field from source table i.e VBAK-BSTNK in the report.
5. Some of sales document values associated with PO numbers are given below as in NEP System:

Untitled1.png

Release Information


None